package com.atguigu.tingshu.album.mapper;

import com.atguigu.tingshu.model.album.AlbumInfo;
import com.atguigu.tingshu.query.album.AlbumInfoQuery;
import com.atguigu.tingshu.vo.album.AlbumListVo;
import com.atguigu.tingshu.vo.album.AlbumStatVo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface AlbumInfoMapper extends BaseMapper<AlbumInfo> {

    /**
     * 分页查询用户专辑列表
     * @param page
     * @param albumInfoQuery
     * @return
     */
    IPage<AlbumListVo> selectUserAlbumPage(@Param("vo") AlbumInfoQuery albumInfoQuery, Page<AlbumListVo> page);

    /**
     *
     * 获取专辑统计信息
     * @param albumId
     * @return
     */
    AlbumStatVo selectAlbumStatVo(@Param("albumId") Long albumId);

    /**
     * 更新专辑播放统计信息
     * @param albumId
     * @param trackStatPlay
     * @param count
     */
    @Update("update album_stat set stat_num=stat_num+#{count} where album_id=#{albumId} and stat_type=#{trackStatPlay} and is_deleted = 0")
    void updateTrackStat(@Param("albumId") Long albumId, @Param("trackStatPlay") String trackStatPlay, @Param("count") Integer count);
}
